
<!DOCTYPE HTML>
<html lang="" >
    <head>
        <meta charset="UTF-8">
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <title>MySQL调优 · 野火IM开发手册</title>
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <meta name="description" content="">
        <meta name="generator" content="GitBook 3.2.3">
        <meta name="author" content="野火IM">
        
        
    
    <link rel="stylesheet" href="../gitbook/style.css">

    
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-search-plus/search.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-prism/prism-base16-ateliersulphurpool.light.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-anchors/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-emphasize/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-splitter/splitter.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-tbfed-pagefooter/footer.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.css">
                
            
                
                <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-sectionx/sectionx.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-anchor-navigation-ex/style/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-terminal/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-alerts/style.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-navigator/plugin.css">
                
            
                
                <link rel="stylesheet" href="../gitbook/gitbook-plugin-fontsettings/website.css">
                
            
        

    

    
        
    
        
    

        
    
    
    
    
    <meta name="HandheldFriendly" content="true"/>
    <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
    <meta name="apple-mobile-web-app-capable" content="yes">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
    <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">

    
    <link rel="next" href="hardware_requirement.html" />
    
    
    <link rel="prev" href="server_clean.html" />
    

    
        <link rel="shortcut icon" href='../favicon.ico' type="image/x-icon">
    
    
        <link rel="bookmark" href='../favicon.ico' type="image/x-icon">
    
    
    

    <style>
    @media only screen and (max-width: 640px) {
        .book-header .hidden-mobile {
            display: none;
        }
    }
    </style>
    <script>
        window["gitbook-plugin-github-buttons"] = {"repo":"wildfirechat/server","types":["star"],"size":"small"};
    </script>

    </head>
    <body>
        
<div class="book">
    <div class="book-summary">
        
            
<div id="book-search-input" role="search">
    <input type="text" placeholder="Type to search" />
</div>

            
                <nav role="navigation">
                


<ul class="summary">
    
    
    
        
        <li>
            <a href="http://www.wildfirechat.cn" target="_blank" class="custom-link">Home</a>
        </li>
    
    

    
    <li class="divider"></li>
    

    
        
        
    
        <li class="chapter " data-level="1.1" data-path="../">
            
                <a href="../">
            
                    
                        <b>1.1.</b>
                    
                    产品介绍
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2" data-path="../quick_start/">
            
                <a href="../quick_start/">
            
                    
                        <b>1.2.</b>
                    
                    快速开始
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.2.1" data-path="../quick_start/server.html">
            
                <a href="../quick_start/server.html">
            
                    
                        <b>1.2.1.</b>
                    
                    服务器部署
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.2" data-path="../quick_start/android.html">
            
                <a href="../quick_start/android.html">
            
                    
                        <b>1.2.2.</b>
                    
                    安卓编译
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.3" data-path="../quick_start/iOS.html">
            
                <a href="../quick_start/iOS.html">
            
                    
                        <b>1.2.3.</b>
                    
                    iOS编译
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.2.4" data-path="../quick_start/pc.html">
            
                <a href="../quick_start/pc.html">
            
                    
                        <b>1.2.4.</b>
                    
                    PC体验
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.3" data-path="../architecture/">
            
                <a href="../architecture/">
            
                    
                        <b>1.3.</b>
                    
                    系统架构
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4" data-path="../base_knowledge/">
            
                <a href="../base_knowledge/">
            
                    
                        <b>1.4.</b>
                    
                    基础知识
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.4.1" data-path="../base_knowledge/sdk_demo.html">
            
                <a href="../base_knowledge/sdk_demo.html">
            
                    
                        <b>1.4.1.</b>
                    
                    SDK与Demo的关系
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.2" data-path="../base_knowledge/user.html">
            
                <a href="../base_knowledge/user.html">
            
                    
                        <b>1.4.2.</b>
                    
                    用户
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.3" data-path="../base_knowledge/sdk_abilities.html">
            
                <a href="../base_knowledge/sdk_abilities.html">
            
                    
                        <b>1.4.3.</b>
                    
                    SDK的功能
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.4" data-path="../base_knowledge/connect.html">
            
                <a href="../base_knowledge/connect.html">
            
                    
                        <b>1.4.4.</b>
                    
                    连接
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.5" data-path="../base_knowledge/conversation.html">
            
                <a href="../base_knowledge/conversation.html">
            
                    
                        <b>1.4.5.</b>
                    
                    会话
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.6" data-path="../base_knowledge/message.html">
            
                <a href="../base_knowledge/message.html">
            
                    
                        <b>1.4.6.</b>
                    
                    消息
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.7" data-path="../base_knowledge/message_content.html">
            
                <a href="../base_knowledge/message_content.html">
            
                    
                        <b>1.4.7.</b>
                    
                    消息内容
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.8" data-path="../base_knowledge/message_payload.html">
            
                <a href="../base_knowledge/message_payload.html">
            
                    
                        <b>1.4.8.</b>
                    
                    消息负载
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.9" data-path="../base_knowledge/storage_and_sync.html">
            
                <a href="../base_knowledge/storage_and_sync.html">
            
                    
                        <b>1.4.9.</b>
                    
                    存储与同步
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.10" data-path="../base_knowledge/offline_message.html">
            
                <a href="../base_knowledge/offline_message.html">
            
                    
                        <b>1.4.10.</b>
                    
                    离线消息
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.11" data-path="../base_knowledge/group.html">
            
                <a href="../base_knowledge/group.html">
            
                    
                        <b>1.4.11.</b>
                    
                    群组
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.12" data-path="../base_knowledge/chatroom.html">
            
                <a href="../base_knowledge/chatroom.html">
            
                    
                        <b>1.4.12.</b>
                    
                    聊天室
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.4.13" data-path="../base_knowledge/custom_message_content.html">
            
                <a href="../base_knowledge/custom_message_content.html">
            
                    
                        <b>1.4.13.</b>
                    
                    自定义消息内容
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.5" data-path="./">
            
                <a href="./">
            
                    
                        <b>1.5.</b>
                    
                    服务器说明
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.1" data-path="server_port.html">
            
                <a href="server_port.html">
            
                    
                        <b>1.5.1.</b>
                    
                    服务器端口说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.2" data-path="db_config.html">
            
                <a href="db_config.html">
            
                    
                        <b>1.5.2.</b>
                    
                    数据库配置
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.3" data-path="server_memory.html">
            
                <a href="server_memory.html">
            
                    
                        <b>1.5.3.</b>
                    
                    机器内存的选择
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.4" data-path="benchmark.html">
            
                <a href="benchmark.html">
            
                    
                        <b>1.5.4.</b>
                    
                    性能测试
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.5" data-path="server_config.html">
            
                <a href="server_config.html">
            
                    
                        <b>1.5.5.</b>
                    
                    服务器配置
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6" data-path="admin_api/">
            
                <a href="admin_api/">
            
                    
                        <b>1.5.6.</b>
                    
                    Server API接口
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.5.6.1" data-path="admin_api/user_api.html">
            
                <a href="admin_api/user_api.html">
            
                    
                        <b>1.5.6.1.</b>
                    
                    用户
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.2" data-path="admin_api/user_relation.html">
            
                <a href="admin_api/user_relation.html">
            
                    
                        <b>1.5.6.2.</b>
                    
                    用户关系
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.3" data-path="admin_api/robot_api.html">
            
                <a href="admin_api/robot_api.html">
            
                    
                        <b>1.5.6.3.</b>
                    
                    机器人
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.4" data-path="admin_api/message_api.html">
            
                <a href="admin_api/message_api.html">
            
                    
                        <b>1.5.6.4.</b>
                    
                    消息
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.5" data-path="admin_api/group_api.html">
            
                <a href="admin_api/group_api.html">
            
                    
                        <b>1.5.6.5.</b>
                    
                    群组
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.6" data-path="admin_api/chatroom_api.html">
            
                <a href="admin_api/chatroom_api.html">
            
                    
                        <b>1.5.6.6.</b>
                    
                    聊天室
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.7" data-path="admin_api/sensitive_word_api.html">
            
                <a href="admin_api/sensitive_word_api.html">
            
                    
                        <b>1.5.6.7.</b>
                    
                    敏感词
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.6.8" data-path="admin_api/error_code.html">
            
                <a href="admin_api/error_code.html">
            
                    
                        <b>1.5.6.8.</b>
                    
                    code状态码
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.5.7" data-path="sdk.html">
            
                <a href="sdk.html">
            
                    
                        <b>1.5.7.</b>
                    
                    Server SDK
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.8" data-path="robot_api/">
            
                <a href="robot_api/">
            
                    
                        <b>1.5.8.</b>
                    
                    Robot API接口
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.9" data-path="event_callback.html">
            
                <a href="event_callback.html">
            
                    
                        <b>1.5.9.</b>
                    
                    事件回调
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.10" data-path="push_config.html">
            
                <a href="push_config.html">
            
                    
                        <b>1.5.10.</b>
                    
                    推送说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.11" data-path="media_server.html">
            
                <a href="media_server.html">
            
                    
                        <b>1.5.11.</b>
                    
                    媒体服务
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.12" data-path="server_clean.html">
            
                <a href="server_clean.html">
            
                    
                        <b>1.5.12.</b>
                    
                    服务的维护
            
                </a>
            

            
        </li>
    
        <li class="chapter active" data-level="1.5.13" data-path="mysql_tune.html">
            
                <a href="mysql_tune.html">
            
                    
                        <b>1.5.13.</b>
                    
                    MySQL调优
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.14" data-path="hardware_requirement.html">
            
                <a href="hardware_requirement.html">
            
                    
                        <b>1.5.14.</b>
                    
                    硬件要求
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.15" data-path="upgrade.html">
            
                <a href="upgrade.html">
            
                    
                        <b>1.5.15.</b>
                    
                    升级指南
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.5.16" data-path="client_database_secret.html">
            
                <a href="client_database_secret.html">
            
                    
                        <b>1.5.16.</b>
                    
                    客户端数据库密钥
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.6" data-path="../android/">
            
                <a href="../android/">
            
                    
                        <b>1.6.</b>
                    
                    Android开发
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.6.1" data-path="../android/compile.html">
            
                <a href="../android/compile.html">
            
                    
                        <b>1.6.1.</b>
                    
                    代码编译与工程说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.2" data-path="../android/chatclient.html">
            
                <a href="../android/chatclient.html">
            
                    
                        <b>1.6.2.</b>
                    
                    ChatClient简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.3" data-path="../android/chatuikit.html">
            
                <a href="../android/chatuikit.html">
            
                    
                        <b>1.6.3.</b>
                    
                    ChatUIKit简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.4" data-path="../android/wildfirechat.html">
            
                <a href="../android/wildfirechat.html">
            
                    
                        <b>1.6.4.</b>
                    
                    WildfireChat简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.6.5" data-path="../android/push.html">
            
                <a href="../android/push.html">
            
                    
                        <b>1.6.5.</b>
                    
                    推送集成
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.7" data-path="../ios/">
            
                <a href="../ios/">
            
                    
                        <b>1.7.</b>
                    
                    iOS开发
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.7.1" data-path="../ios/compile.html">
            
                <a href="../ios/compile.html">
            
                    
                        <b>1.7.1.</b>
                    
                    代码编译与工程说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.2" data-path="../ios/chatclient.html">
            
                <a href="../ios/chatclient.html">
            
                    
                        <b>1.7.2.</b>
                    
                    ChatClient简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.3" data-path="../ios/chatuikit.html">
            
                <a href="../ios/chatuikit.html">
            
                    
                        <b>1.7.3.</b>
                    
                    ChatUIKit简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.4" data-path="../ios/wildfirechat.html">
            
                <a href="../ios/wildfirechat.html">
            
                    
                        <b>1.7.4.</b>
                    
                    WildfireChat简介
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.7.5" data-path="../ios/push.html">
            
                <a href="../ios/push.html">
            
                    
                        <b>1.7.5.</b>
                    
                    推送集成
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.8" data-path="../webrtc/">
            
                <a href="../webrtc/">
            
                    
                        <b>1.8.</b>
                    
                    音视频
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.9" data-path="../base_knowledge/maintain.html">
            
                <a href="../base_knowledge/maintain.html">
            
                    
                        <b>1.9.</b>
                    
                    维护说明
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.10" >
            
                <a target="_blank" href="https://github.com/wildfirechat/im-app_server/blob/master/README.md">
            
                    
                        <b>1.10.</b>
                    
                    应用服务
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.11" >
            
                <a target="_blank" href="https://github.com/wildfirechat/push_server/blob/master/README.md">
            
                    
                        <b>1.11.</b>
                    
                    推送服务
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.12" >
            
                <a target="_blank" href="https://github.com/wildfirechat/robot_server/blob/master/README.md">
            
                    
                        <b>1.12.</b>
                    
                    机器人服务
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13" data-path="../faq/">
            
                <a href="../faq/">
            
                    
                        <b>1.13.</b>
                    
                    常见问题
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.1" data-path="../faq/general.html">
            
                <a href="../faq/general.html">
            
                    
                        <b>1.13.1.</b>
                    
                    通用问题
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.1.1" data-path="../faq/buy.html">
            
                <a href="../faq/buy.html">
            
                    
                        <b>1.13.1.1.</b>
                    
                    购买流程
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.13.2" data-path="../faq/server.html">
            
                <a href="../faq/server.html">
            
                    
                        <b>1.13.2.</b>
                    
                    服务器问题
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.2.1" data-path="../faq/server/q1.html">
            
                <a href="../faq/server/q1.html">
            
                    
                        <b>1.13.2.1.</b>
                    
                    如何导入到IDE中
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13.2.2" data-path="../faq/server/q2.html">
            
                <a href="../faq/server/q2.html">
            
                    
                        <b>1.13.2.2.</b>
                    
                    如何解决等登陆但一直连接中的问题
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.13.3" data-path="../faq/android.html">
            
                <a href="../faq/android.html">
            
                    
                        <b>1.13.3.</b>
                    
                    安卓问题
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.3.1" data-path="../faq/android/q1.html">
            
                <a href="../faq/android/q1.html">
            
                    
                        <b>1.13.3.1.</b>
                    
                    如何导入到Android Studio中
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13.3.2" data-path="../faq/android/q2.html">
            
                <a href="../faq/android/q2.html">
            
                    
                        <b>1.13.3.2.</b>
                    
                    如何集成到现有项目中
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.13.4" data-path="../faq/ios.html">
            
                <a href="../faq/ios.html">
            
                    
                        <b>1.13.4.</b>
                    
                    iOS问题
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13.5" data-path="../faq/web.html">
            
                <a href="../faq/web.html">
            
                    
                        <b>1.13.5.</b>
                    
                    Web问题
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13.6" data-path="../faq/practicality.html">
            
                <a href="../faq/practicality.html">
            
                    
                        <b>1.13.6.</b>
                    
                    最佳实践
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.13.6.1" data-path="../faq/practicality/stickers.html">
            
                <a href="../faq/practicality/stickers.html">
            
                    
                        <b>1.13.6.1.</b>
                    
                    小表情大世界
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.13.6.2" data-path="../faq/practicality/online_match.html">
            
                <a href="../faq/practicality/online_match.html">
            
                    
                        <b>1.13.6.2.</b>
                    
                    在线匹配
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="1.14" data-path="../blogs/">
            
                <a href="../blogs/">
            
                    
                        <b>1.14.</b>
                    
                    文章
            
                </a>
            

            
            <ul class="articles">
                
    
        <li class="chapter " data-level="1.14.1" data-path="../blogs/如何开发一款微信.html">
            
                <a href="../blogs/如何开发一款微信.html">
            
                    
                        <b>1.14.1.</b>
                    
                    如何开发一款微信
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.2" data-path="../blogs/如何修改野火应用服务生成用户名的策略.html">
            
                <a href="../blogs/如何修改野火应用服务生成用户名的策略.html">
            
                    
                        <b>1.14.2.</b>
                    
                    如何修改野火应用服务生成用户名的策略
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.3" data-path="../blogs/苹果ATS处理.html">
            
                <a href="../blogs/苹果ATS处理.html">
            
                    
                        <b>1.14.3.</b>
                    
                    苹果ATS处理
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.4" data-path="../blogs/野火IM的商业逻辑.html">
            
                <a href="../blogs/野火IM的商业逻辑.html">
            
                    
                        <b>1.14.4.</b>
                    
                    野火IM的商业逻辑
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.5" data-path="../blogs/如何理解野火IM设计理念.html">
            
                <a href="../blogs/如何理解野火IM设计理念.html">
            
                    
                        <b>1.14.5.</b>
                    
                    如何理解野火IM设计理念
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.6" data-path="../blogs/为什么野火IM不全免费.html">
            
                <a href="../blogs/为什么野火IM不全免费.html">
            
                    
                        <b>1.14.6.</b>
                    
                    为什么野火IM不全免费
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.7" data-path="../blogs/开发运营社交软件也要遵守法律.html">
            
                <a href="../blogs/开发运营社交软件也要遵守法律.html">
            
                    
                        <b>1.14.7.</b>
                    
                    开发运营社交软件也要遵守法律
            
                </a>
            

            
        </li>
    
        <li class="chapter " data-level="1.14.8" data-path="../blogs/如何实现聊天记录的备份与恢复.html">
            
                <a href="../blogs/如何实现聊天记录的备份与恢复.html">
            
                    
                        <b>1.14.8.</b>
                    
                    如何实现聊天记录的备份与恢复
            
                </a>
            

            
        </li>
    

            </ul>
            
        </li>
    

    

    <li class="divider"></li>

    <li>
        <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
            Published with GitBook
        </a>
    </li>
</ul>


                </nav>
            
        
    </div>

    <div class="book-body">
        
            <div class="body-inner">
                
                    

<div class="book-header" role="navigation">
    

    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href=".." >MySQL调优</a>
    </h1>
</div>




                    <div class="page-wrapper" tabindex="-1" role="main">
                        <div class="page-inner">
                            
<div id="book-search-results">
    <div class="search-noresults">
    
                                <section class="normal markdown-section">
                                
                                <div id="anchor-navigation-ex-navbar"><i class="fa fa-anchor"></i><ul><li><a href="#mysql-&#x8C03;&#x4F18;">MySQL &#x8C03;&#x4F18;</a></li></ul></div><a href="#mysql-&#x8C03;&#x4F18;" id="anchorNavigationExGoTop"><i class="fa fa-arrow-up"></i></a><h1 id="MySQL_&#x8C03;&#x4F18;"><a name="mysql-&#x8C03;&#x4F18;" class="anchor-navigation-ex-anchor" href="#mysql-&#x8C03;&#x4F18;"><i class="fa fa-link" aria-hidden="true"></i></a>MySQL &#x8C03;&#x4F18;</h1>
<h3 id="1&#xFF0C;&#x6240;&#x6709;&#x7684;&#x8868;&#x90FD;&#x5FC5;&#x987B;&#x6709;primary_key_">0.1. 1&#xFF0C;&#x6240;&#x6709;&#x7684;&#x8868;&#x90FD;&#x5FC5;&#x987B;&#x6709;primary key.</h3>
<p>&#x56E0;&#x4E3A;&#x9700;&#x8981;&#x7528;primary key&#x6765;&#x8868;&#x793A;&#x6BCF;&#x4E00;&#x884C;&#xFF0C;&#x6700;&#x597D;&#x7528;&#x81EA;&#x589E;&#x7684;&#x6574;&#x5F62;</p>
<h3 id="2&#xFF0C;_&#x4F7F;&#x7528;in&#x4EE3;&#x66FF;or">0.2. 2&#xFF0C; &#x4F7F;&#x7528;in&#x4EE3;&#x66FF;or</h3>
<p>SELECT * FROM t WHERE LOC_IN IN (10,20,30);</p>
<h3 id="3&#xFF0C;_&#x4E0D;&#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;">0.3. 3&#xFF0C; &#x4E0D;&#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;</h3>
<p>&#x4F7F;&#x7528;join</p>
<h3 id="4__&#x8DB3;&#x591F;&#x5927;&#x7684;_innodb_buffer_pool_size">0.4. 4. &#x8DB3;&#x591F;&#x5927;&#x7684; innodb_buffer_pool_size</h3>
<p>&#x6700;&#x5927;&#x5185;&#x5B58;&#x6570;&#x5728;&#x603B;&#x7684;innoDB&#x5185;&#x5B58;&#x6570;&#x636E;160%&#x5C31;&#x884C;&#xFF0C;&#x6BD4;&#x5982;&#x6570;&#x636E;&#x5927;&#x5C0F;5G&#xFF0C;buffer size&#x8BBE;&#x7F6E;&#x4E3A;8G&#x5C31;&#x884C;&#xFF0C;&#x6709;&#x4E2A;&#x547D;&#x4EE4;&#x6765;&#x83B7;&#x53D6;&#x5E94;&#x5F53;&#x8BBE;&#x7F6E;&#x7684;&#x5927;&#x5C0F;</p>
<pre class="language-"><code>SELECT CEILING(Total_InnoDB_Bytes*1.6/POWER(1024,3)) RIBPS FROM
(SELECT SUM(data_length+index_length) Total_InnoDB_Bytes
FROM information_schema.tables WHERE engine=&apos;InnoDB&apos;) A;
</code></pre><blockquote>
<p>&#x9700;&#x8981;&#x6CE8;&#x610F;&#x8FD9;&#x4E2A;&#x7CFB;&#x7EDF;&#x521A;&#x5F00;&#x59CB;&#x5141;&#x8BB8;&#xFF0C;&#x65E0;&#x6CD5;&#x8BA1;&#x7B97;&#x51FA;&#x5B9E;&#x9645;&#x4F7F;&#x7528;&#x91CF;&#x3002;&#x4E00;&#x822C;&#x9700;&#x8981;&#x7CFB;&#x7EDF;&#x5B9E;&#x9645;&#x5141;&#x8BB8;&#x51E0;&#x4E2A;&#x6708;&#xFF0C;&#x6216;&#x8005;&#x8BBE;&#x7F6E;&#x6210;&#x673A;&#x5668;&#x7269;&#x7406;&#x5185;&#x5B58;&#x7684;&#x4E00;&#x534A;&#x3002;</p>
</blockquote>
<hr>
<h3 id="5__&#x914D;&#x7F6E;_innodb_log_file_size">0.5. 5. &#x914D;&#x7F6E; innodb_log_file_size</h3>
<p>&#x4F7F;&#x7528;&#x8DB3;&#x591F;&#x5927;&#x7684;&#x5199;&#x5165;&#x7F13;&#x5B58; innodb_log_file_size</p>
<p>&#x53EF;&#x662F;&#x987B;&#x8981;&#x6CE8;&#x610F;&#x5047;&#x8BBE;&#x7528; 1G &#x7684; innodb_log_file_size &#x3002;&#x5047;&#x5982;server&#x5F53;&#x673A;&#x3002;&#x987B;&#x8981; 10 &#x5206;&#x949F;&#x6765;&#x6062;&#x590D;&#x3002;</p>
<p>&#x63A8;&#x8350; innodb_log_file_size &#x8BBE;&#x7F6E;&#x4E3A; 0.25 * innodb_buffer_pool_size</p>
<hr>
<h3 id="6__&#x914D;&#x7F6E;_innodb_flush_log_at_trx_commit">0.6. 6. &#x914D;&#x7F6E; innodb_flush_log_at_trx_commit</h3>
<p>innodb_flush_log_at_trx_commit = 1 &#x5219;&#x6BCF;&#x6B21;&#x6539;&#x52A8;&#x5199;&#x5165;&#x78C1;&#x76D8;</p>
<p>innodb_flush_log_at_trx_commit = 0/2 &#x6BCF;&#x79D2;&#x5199;&#x5165;&#x78C1;&#x76D8;</p>
<p>&#x5047;&#x8BBE;&#x4F60;&#x7684;&#x5E94;&#x7528;&#x4E0D;&#x6D89;&#x53CA;&#x975E;&#x5E38;&#x9AD8;&#x7684;&#x5B89;&#x5168;&#x6027; (&#x91D1;&#x878D;&#x7CFB;&#x7EDF;)&#xFF0C;&#x6216;&#x8005;&#x57FA;&#x7840;&#x67B6;&#x6784;&#x8DB3;&#x591F;&#x5B89;&#x5168;&#xFF0C;&#x6216;&#x8005; &#x4E8B;&#x52A1;&#x90FD;&#x975E;&#x5E38;&#x5C0F;&#xFF0C;&#x90FD;&#x80FD;&#x591F;&#x7528; 0 &#x6216;&#x8005; 2 &#x6765;&#x51CF;&#x5C11;&#x78C1;&#x76D8;&#x64CD;&#x4F5C;&#x3002;</p>
<hr>
<h3 id="7__&#x907F;&#x514D;&#x53CC;&#x5199;&#x5165;&#x7F13;&#x51B2;">0.7. 7. &#x907F;&#x514D;&#x53CC;&#x5199;&#x5165;&#x7F13;&#x51B2;</h3>
<p>innodb_flush_method=O_DIRECT</p>
<hr>
<h3 id="8__innodb_write_io_threads">0.8. 8. innodb_write_io_threads</h3>
<p>&#x5199;IO&#x7EBF;&#x7A0B;&#xFF0C;&#x9ED8;&#x8BA4;4&#xFF0C;&#x6700;&#x5927;&#x53EF;&#x8BBE;&#x7F6E;&#x6210;64.&#x6BCF;&#x4E2A;&#x7EBF;&#x7A0B;&#x53EF;&#x4EE5;&#x5904;&#x7406;256&#x4E2A;pending io request.&#x9700;&#x8981;&#x6839;&#x636E;&#x60A8;&#x7684;cpu&#x6570;&#x548C;&#x8BFB;&#x5199;&#x6BD4;&#x4F8B;&#x8C03;&#x6574;&#xFF0C;&#x5728;&#x5F53;&#x524D;&#x9879;&#x76EE;&#x4E2D;&#x53EF;&#x8BBE;&#x7F6E;&#x4E3A;&#x7269;&#x7406;&#x6838;&#x6570;&#x7684;2&#x500D;</p>
<hr>
<h3 id="9__innodb_read_io_threads">0.9. 9. innodb_read_io_threads</h3>
<p>&#x8BFB;IO&#x7EBF;&#x7A0B;&#xFF0C;&#x9ED8;&#x8BA4;4&#xFF0C;&#x6700;&#x5927;&#x53EF;&#x8BBE;&#x7F6E;&#x6210;64.&#x6BCF;&#x4E2A;&#x7EBF;&#x7A0B;&#x53EF;&#x4EE5;&#x5904;&#x7406;256&#x4E2A;pending io request.&#x9700;&#x8981;&#x6839;&#x636E;&#x60A8;&#x7684;cpu&#x6570;&#x548C;&#x8BFB;&#x5199;&#x6BD4;&#x4F8B;&#x8C03;&#x6574;&#xFF0C;&#x5728;&#x5F53;&#x524D;&#x9879;&#x76EE;&#x4E2D;&#x4FDD;&#x6301;4&#x5C31;&#x53EF;&#x4EE5;&#x4E86;</p>
<hr>
<h3 id="10__innodb_thread_concurrency">0.10. 10. innodb_thread_concurrency</h3>
<p>&#x7EBF;&#x7A0B;&#x5E76;&#x53D1;&#x6570;&#xFF0C;0&#x662F;&#x4E0D;&#x9650;&#x5236;&#x3002;&#x5982;&#x679C;&#x8BBE;&#x7F6E;&#x6700;&#x5927;&#x662F;1000&#xFF0C;&#x53EF;&#x4EE5;&#x8BBE;&#x7F6E;&#x6210;cpu&#x6838;&#x6570;&#x7684;8&#x500D;</p>
<hr>
<h3 id="11__&#x5173;&#x95ED;swap">0.11. 11. &#x5173;&#x95ED;swap</h3>
<p>&#x5BF9;&#x4E8E;&#x5355;&#x72EC;&#x7684;&#x6570;&#x636E;&#x5E93;&#x670D;&#x52A1;&#x5668;&#xFF0C;&#x5728;&#x5185;&#x5B58;&#x8DB3;&#x591F;&#x5927;&#x7684;&#x60C5;&#x51B5;&#x4E0B;&#xFF0C;&#x53EF;&#x4EE5;&#x5173;&#x95ED;swap</p>
<pre class="language-"><code>sync                         # &#x5148;&#x6267;&#x884C;&#x4E0B;&#x540C;&#x6B65;
swapoff -a                   # &#x5173;&#x95ED;swap&#x5206;&#x533A;
swapon -a                    # &#x5F00;&#x542F;swap&#x5206;&#x533A;
swapoff -a &amp;&amp; swapon -a      # &#x5237;&#x65B0;swap&#x7A7A;&#x95F4;&#xFF0C;&#x5373;&#x5C06;SWAP&#x91CC;&#x7684;&#x6570;&#x636E;&#x8F6C;&#x50A8;&#x56DE;&#x5185;&#x5B58;&#xFF0C;&#x5E76;&#x6E05;&#x7A7A;SWAP&#x91CC;&#x7684;&#x6570;&#x636E;&#x3002;&#x5237;&#x65B0;&#x539F;&#x7406;&#x5C31;&#x662F;&#x628A;swap&#x5173;&#x95ED;&#x540E;&#x518D;&#x91CD;&#x542F;&#x3002;
</code></pre><hr>
<h3 id="12__DB&#x8FDE;&#x63A5;&#x6570;">0.12. 12. DB&#x8FDE;&#x63A5;&#x6570;</h3>
<p>show global variables like &quot;max_connections&quot;; &#x663E;&#x793A;&#x6700;&#x5927;&#x8FDE;&#x63A5;&#x6570;
SET GLOBAL max_connections = 2000; &#x8BBE;&#x7F6E;&#x6700;&#x5927;&#x8FDE;&#x63A5;&#x6570;</p>
<h3 id="13__c3p0&#x8FDE;&#x63A5;&#x6C60;">0.13. 13. c3p0&#x8FDE;&#x63A5;&#x6C60;</h3>
<p>&#x4FEE;&#x6539;&#x6700;&#x5927;&#x8FDE;&#x63A5;&#x6570;&#xFF0C;&#x6CE8;&#x610F;&#x9700;&#x8981;&#x786E;&#x4FDD;DB&#x80FD;&#x6491;&#x5F97;&#x8D77;&#x96C6;&#x7FA4;&#x7684;&#x6700;&#x5927;&#x8FDE;&#x63A5;&#x6570;</p>
<h3 id="14__&#x793A;&#x4F8B;">0.14. 14. &#x793A;&#x4F8B;</h3>
<p>mysqld.cnf&#x914D;&#x7F6E;</p>
<pre class="language-"><code>[mysqld]
    # Uncomment the following if you are using InnoDB tables
    #innodb_data_home_dir = /usr/local/mysql/data
    #innodb_data_file_path = ibdata1:10M:autoextend
    #innodb_log_group_home_dir = /usr/local/mysql/data
    # You can set .._buffer_pool_size up to 50 - 80 %
    # of RAM but beware of setting memory usage too high
    innodb_buffer_pool_size = 2G
    # Set .._log_file_size to 25 % of buffer pool size
    innodb_log_file_size = 512M
    innodb_log_buffer_size = 64M
    innodb_flush_log_at_trx_commit = 2
    innodb_flush_method=O_DIRECT
    #innodb_lock_wait_timeout = 50
</code></pre><blockquote>
<p>&#x4EE5;&#x4E0A;&#x4FE1;&#x606F;&#x6765;&#x6E90;&#x4E8E;</p>
<p><a href="https://www.cnblogs.com/jxldjsn/p/6010720.html" target="_blank">https://www.cnblogs.com/jxldjsn/p/6010720.html</a></p>
<p><a href="https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/" target="_blank">https://www.percona.com/blog/2016/10/12/mysql-5-7-performance-tuning-immediately-after-installation/</a></p>
<p><a href="https://www.cnblogs.com/claireyuancy/p/7258314.html" target="_blank">https://www.cnblogs.com/claireyuancy/p/7258314.html</a></p>
<p><a href="http://www.codingpedia.org/ama/optimizing-mysql-server-settings/" target="_blank">http://www.codingpedia.org/ama/optimizing-mysql-server-settings/</a></p>
</blockquote>
<footer class="page-footer"><span class="copyright">2018 &#xA9; wildfirechat.cn &#x4EAC;ICP&#x5907;18060403&#x53F7;-1 all right reserved&#xFF0C;powered by Gitbook</span><span class="footer-modification">&#x8BE5;&#x6587;&#x4EF6;&#x4FEE;&#x8BA2;&#x65F6;&#x95F4;&#xFF1A;
2019-05-07 19:06:24
</span></footer><div id="anchors-navbar"><i class="fa fa-anchor"></i><ul><p><a href="#MySQL_&#x8C03;&#x4F18;">MySQL &#x8C03;&#x4F18;</a></p><li><a href="#">none</a></li><ul><li><a href="#1&#xFF0C;&#x6240;&#x6709;&#x7684;&#x8868;&#x90FD;&#x5FC5;&#x987B;&#x6709;primary_key_">0.1. 1&#xFF0C;&#x6240;&#x6709;&#x7684;&#x8868;&#x90FD;&#x5FC5;&#x987B;&#x6709;primary key.</a></li><li><a href="#2&#xFF0C;_&#x4F7F;&#x7528;in&#x4EE3;&#x66FF;or">0.2. 2&#xFF0C; &#x4F7F;&#x7528;in&#x4EE3;&#x66FF;or</a></li><li><a href="#3&#xFF0C;_&#x4E0D;&#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;">0.3. 3&#xFF0C; &#x4E0D;&#x4F7F;&#x7528;&#x5B50;&#x67E5;&#x8BE2;</a></li><li><a href="#4__&#x8DB3;&#x591F;&#x5927;&#x7684;_innodb_buffer_pool_size">0.4. 4. &#x8DB3;&#x591F;&#x5927;&#x7684; innodb_buffer_pool_size</a></li><li><a href="#5__&#x914D;&#x7F6E;_innodb_log_file_size">0.5. 5. &#x914D;&#x7F6E; innodb_log_file_size</a></li><li><a href="#6__&#x914D;&#x7F6E;_innodb_flush_log_at_trx_commit">0.6. 6. &#x914D;&#x7F6E; innodb_flush_log_at_trx_commit</a></li><li><a href="#7__&#x907F;&#x514D;&#x53CC;&#x5199;&#x5165;&#x7F13;&#x51B2;">0.7. 7. &#x907F;&#x514D;&#x53CC;&#x5199;&#x5165;&#x7F13;&#x51B2;</a></li><li><a href="#8__innodb_write_io_threads">0.8. 8. innodb_write_io_threads</a></li><li><a href="#9__innodb_read_io_threads">0.9. 9. innodb_read_io_threads</a></li><li><a href="#10__innodb_thread_concurrency">0.10. 10. innodb_thread_concurrency</a></li><li><a href="#11__&#x5173;&#x95ED;swap">0.11. 11. &#x5173;&#x95ED;swap</a></li><li><a href="#12__DB&#x8FDE;&#x63A5;&#x6570;">0.12. 12. DB&#x8FDE;&#x63A5;&#x6570;</a></li><li><a href="#13__c3p0&#x8FDE;&#x63A5;&#x6C60;">0.13. 13. c3p0&#x8FDE;&#x63A5;&#x6C60;</a></li><li><a href="#14__&#x793A;&#x4F8B;">0.14. 14. &#x793A;&#x4F8B;</a></li></ul></ul></div><a href="#" id="goTop"><i class="fa fa-arrow-up"></i></a>
                                
                                </section>
                            
    </div>
    <div class="search-results">
        <div class="has-results">
            
            <h1 class="search-results-title"><span class='search-results-count'></span> results matching "<span class='search-query'></span>"</h1>
            <ul class="search-results-list"></ul>
            
        </div>
        <div class="no-results">
            
            <h1 class="search-results-title">No results matching "<span class='search-query'></span>"</h1>
            
        </div>
    </div>
</div>

                        </div>
                    </div>
                
            </div>

            
                
                <a href="server_clean.html" class="navigation navigation-prev " aria-label="Previous page: 服务的维护">
                    <i class="fa fa-angle-left"></i>
                </a>
                
                
                <a href="hardware_requirement.html" class="navigation navigation-next " aria-label="Next page: 硬件要求">
                    <i class="fa fa-angle-right"></i>
                </a>
                
            
        
    </div>

    <script>
        var gitbook = gitbook || [];
        gitbook.push(function() {
            gitbook.page.hasChanged({"page":{"title":"MySQL调优","level":"1.5.13","depth":2,"next":{"title":"硬件要求","level":"1.5.14","depth":2,"path":"server/hardware_requirement.md","ref":"server/hardware_requirement.md","articles":[]},"previous":{"title":"服务的维护","level":"1.5.12","depth":2,"path":"server/server_clean.md","ref":"server/server_clean.md","articles":[]},"dir":"ltr"},"config":{"plugins":["-lunr","-search","-highlight","-livereload","search-plus@^0.0.11","simple-page-toc@^0.1.1","github@^2.0.0","github-buttons@2.1.0","prism@^2.1.0","prism-themes@^0.0.2","anchors@^0.7.1","emphasize@^1.1.0","splitter@^0.0.8","tbfed-pagefooter@^0.0.1","expandable-chapters-small@^0.1.7","sectionx@^3.1.0","sitemap-general@^0.1.1","anchor-navigation-ex@0.1.8","favicon@^0.0.2","todo@^0.1.3","3-ba@^0.9.0","terminal@^0.3.2","alerts@^0.2.0","include-csv@^0.1.0","-sharing","sharing-plus@^0.0.2","include-codeblock@^3.0.2","navigator"],"styles":{"website":"styles/website.css","ebook":"styles/ebook.css"},"pluginsConfig":{"tbfed-pagefooter":{"copyright":"2018 © wildfirechat.cn 京ICP备18060403号-1","modify_label":"该文件修订时间：","modify_format":"YYYY-MM-DD HH:mm:ss"},"prism":{"css":["prism-themes/themes/prism-base16-ateliersulphurpool.light.css"]},"include-csv":{},"disqus":{"shortName":"gitbookuse"},"emphasize":{},"github":{"url":"https://github.com/wildfirechat/docs"},"simple-page-toc":{"maxDepth":3,"skipFirstH1":true},"todo":{},"splitter":{},"sharing-plus":{"qq":false,"all":["facebook","google","twitter","instapaper","linkedin","pocket","stumbleupon"],"douban":false,"facebook":true,"weibo":false,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":true,"messenger":false,"line":false,"vk":false,"pocket":true,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":false},"sitemap-general":{"prefix":"http://wildfirechat.cn"},"fontsettings":{"theme":"white","family":"sans","size":2},"sectionx":{"tag":"b"},"anchor-navigation-ex":{"isRewritePageTitle":false,"tocLevel1Icon":"fa fa-hand-o-right","tocLevel2Icon":"fa fa-hand-o-right","tocLevel3Icon":"fa fa-hand-o-right"},"favicon":{"shortcut":"favicon.ico","bookmark":"favicon.ico"},"prism-themes":{},"navigator":{},"alerts":{},"github-buttons":{"repo":"wildfirechat/server","types":["star"],"size":"small"},"3-ba":{"configuration":"auto","token":"ff100361cdce95dd4c8fb96b4009f7bc"},"expandable-chapters-small":{},"include-codeblock":{"check":false,"edit":true,"fixlang":false,"lang":"","template":"ace","theme":"chrome","unindent":true},"sharing":{"qq":true,"all":["facebook","google","twitter","weibo","instapaper","linkedin","pocket","stumbleupon","qq","qzone"],"douban":false,"facebook":false,"weibo":true,"instapaper":false,"whatsapp":false,"hatenaBookmark":false,"twitter":false,"messenger":false,"line":false,"vk":false,"pocket":false,"google":false,"viber":false,"stumbleupon":false,"qzone":false,"linkedin":true},"terminal":{"copyButtons":true,"fade":false,"style":"flat"},"theme-default":{"styles":{"website":"styles/website.css","pdf":"styles/pdf.css","epub":"styles/epub.css","mobi":"styles/mobi.css","ebook":"styles/ebook.css","print":"styles/print.css"},"showLevel":true},"anchors":{},"search-plus":{}},"theme":"default","author":"野火IM","pdf":{"pageNumbers":true,"fontSize":9,"fontFamily":"Arial","paperSize":"a4","chapterMark":"pagebreak","pageBreaksBefore":"/","margin":{"right":45,"left":45,"top":56,"bottom":56}},"structure":{"langs":"LANGS.md","readme":"README.md","glossary":"GLOSSARY.md","summary":"SUMMARY.md"},"variables":{},"title":"野火IM开发手册","links":{"sidebar":{"Home":"http://www.wildfirechat.cn"}},"gitbook":"*","description":"野火IM开发手册"},"file":{"path":"server/mysql_tune.md","mtime":"2019-05-07T11:06:24.912Z","type":"markdown"},"gitbook":{"version":"3.2.3","time":"2019-12-10T15:11:58.061Z"},"basePath":"..","book":{"language":""}});
        });
    </script>
</div>

        
    <script src="../gitbook/gitbook.js"></script>
    <script src="../gitbook/theme.js"></script>
    
        
        <script src="../gitbook/gitbook-plugin-search-plus/jquery.mark.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-search-plus/search.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-github/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-github-buttons/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-splitter/splitter.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-expandable-chapters-small/expandable-chapters-small.js"></script>
        
    
        
        <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-sectionx/sectionx.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-3-ba/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-terminal/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-alerts/plugin.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-sharing-plus/buttons.js"></script>
        
    
        
        <script src="../gitbook/gitbook-plugin-fontsettings/fontsettings.js"></script>
        
    

    </body>
</html>

